import xlrd


def read_data_from_excel(file, sheet_name="Sheet1"):
    """读取指定的excel
        return： [[],[]]
    """
    datas = xlrd.open_workbook(file)
    table = datas.sheet_by_name(sheet_name)
    return [table.row_values(line) for line in range(1, table.nrows)]




    # count = table.nrows
    # lst = []
    # for line in range(1, count):
    #     lst.append(table.row_values(line))
    # return lst

